Order by hierarchy function

To apply any of function like:

§          Order by hierarchy                                not MDX function, implementation of MDX Hierarhize function

 

for element function you need to

§          … select with mouse desired element (one row) and right-click with mouse

§          … select Element functions menu

for hierarchy function you need to

§          … right-click over member that belongs to desired hierarchy

§          … select Hierarchy functions menu

for axis function you need to

§          … right-click inside row or column area

§          … select Axis functions menu

then select

§          … any Order by hierarchy function from submenu

 

 

In our case let us try to order:

 

presented table result by hierarchy hCountry

You may see that at the bottom of the table are three members from different

level then first thirteen members. Those three members are parents of upper thirteen members.

 

Dialog will appear:

 

 

§          select appropriate option

o         POST                    child members precede their parents

o         NON POST

§          select OK

 

After confirmation result is: